AccountExchGroupRteTable

V8 Message Definiton

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	ConfigGateway
Product	SRConfigGateway
accessType	SELECT,UPDATE,INSERT,DELETE
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
templateName	VARCHAR(32)	PRI	''
clientFirm	VARCHAR(16)	PRI	''
AccntRouteTableList	JSON		'JSON_ARRAY()'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
templateName	1
clientFirm	2

JSON Block (AccntRouteTableList)

Field	Type	Comment
enabled	enum - YesNo
execBrkrCode	enum - execBrkrCode
routeAllocMetric	enum - routeAllocMetric
brkrExDest	enum - brkrExDest	order routing string if any used to force orders use a specific ExDest regardless of the actual exchange destination

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRConfigGateway`.`MsgAccountExchGroupRteTable` (
    `templateName` VARCHAR(32) NOT NULL DEFAULT '',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `AccntRouteTableList` JSON NOT NULL DEFAULT JSON_ARRAY() CHECK(JSON_VALID(AccntRouteTableList)),
    PRIMARY KEY USING HASH (`templateName`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `templateName`,
    `clientFirm`,
    `AccntRouteTableList`
FROM `SRConfigGateway`.`MsgAccountExchGroupRteTable`
WHERE 
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRConfigGateway`.`MsgAccountExchGroupRteTable` 
SET
    /* Replace with a JSON */
    `AccntRouteTableList` = '{"key": "value"}'
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRConfigGateway`.`MsgAccountExchGroupRteTable`(
    /* Replace with a VARCHAR(32) */ 
    `templateName`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a JSON */
    `AccntRouteTableList`
) 
VALUES(
    'Example_templateName',
    'Example_clientFirm',
    '{"key": "value"}'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRConfigGateway`.`MsgAccountExchGroupRteTable` 
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRConfigGateway.doccolumns WHERE TABLE_NAME='AccountExchGroupRteTable' ORDER BY ordinal_position ASC;